SaCreditCardBatchConfig 
Logical Entity Name  SaCreditCardBatchConfig 
Default Table Name  SaCreditCardBatchConfig 
Physical Only  NO 
Definition 
 
Note 
 

SaCreditCardBatchConfig Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SaCreditCardBatchConfigId(PK)    int  NO 
 
Code    varchar(10)  NO 
 
Description    varchar(35)  NO 
 
BatchCount    int  NO 
 
SyStaffGroupID    int  YES 
 
AutoGenerateBatch    bit  NO 
 
TransactionsPerBatch    int  NO 
 
SyPaymentAccountID    int  YES 
 
TimeToSendToProcessor    datetime  YES 
The Processor has a cut-off time, this allows for the user to specify the time to send the batch file
 
IntervalTimeToSendBatches    char(2)  YES 
M- Monthly, D- Daily
 
BatchErrorCmTargetId    int  YES 
 
UserId    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
Ts    timestamp  NO 
 
SuspendAccountOnFailedTransaction    bit  NO 
 
AcctInfo    varchar(100)  YES 
 
UserName    varchar(100)  YES 
 
Password    varchar(100)  YES 
 
SaCreditCardProcessorID(FK)    int  YES 
 
TestMode    bit  NO 
 
Partner    varchar(50)  NO 
 
VendorID    varchar(50)  NO 
 
IV    varchar(100)  YES 
 
SyPaymentProcessorID(FK)    int  YES 
 
AuthAmount    money  NO 
 

SaCreditCardBatchConfig Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_SaCreditCardBatchConfig  PrimaryKey  SaCreditCardBatchConfigId 

SaCreditCardBatchConfig Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SaCreditCardProcessor  Non-Identifying  Zero or One to Zero or More  fk_SaCreditCardBatchConfig_SaCreditCardProcessorID_SaCreditCardProcessor_SaCreditCardProcessorID      SaCreditCardProcessorID  NO  YES 
SyPaymentProcessor  Non-Identifying  Zero or One to Zero or More  FK_SaCreditCardBatchConfig_SyPaymentProcessorID_SyPaymentProcessor_SyPaymentProcessorID      SyPaymentProcessorID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

SaCreditCardBatchConfig Check Constraints 
Check Constraint Name  CheckConstraint